package pig.model;

import java.util.ArrayList;
import java.util.List;

public interface CommonDAO {

	//QNA 게시판	
	public void write(BoardVO bvo);
	public BoardVO showContent(int no);
	public void replyWrite(BoardVO bvo);
	public void deleteBoard(String no);
	public void updateBoard(BoardVO bvo);
	public List<BoardVO> getQNAList(String pageNo, String dealNumber);
	public void updateCount(int no);
	public void updateRestep(int ref, int restep);
	
	// 상품명으로 리스트 찾기
	public List<DealVO> findDealByTitle(String dealName);
	public List<DealVO> findAllDealList();
	public List<DealVO> dealListByCategory(String category);
	public List<DealVO> findDealByEndDate(String category);
	public List<DealVO> findDealByRegisterDate(String category);
	public List<DealVO> findDealByHighPrice(String category);
	public List<DealVO> findDealByLowPrice(String category);
	public List<DealVO> findAllDeal();
	public int totalContentByDeal(String dealNumber);
	
	// 아이디 찾기
	public String findCustomerId(String name, String email);
	public String findSellerId(String name, String email);
	
	// 암호찾기
	public String findCustomerPassword(String id, String email);
	public String findSellerPassword(String id, String email);
	
	// 로그인
	public CustomerVO customerLogin(String id, String password);
	public SellerVO sellerLogin(String id,String password);
	
	//상품 정보 찾기
	public DealVO findDealByNumber(String dealNumber);
	
	//쪽지함
	public void postMessage(PostBoxVO postBoxVO);
	public void postShowContentCheck(int postNumber);
	public PostBoxVO postShowContent(int postNumber);
	public void postSendDeleteCheck(int deleteOk, int postNumber);
	public void postReceiveDeleteCheck(int deleteOk, int postNumber);
	public void deletePost(int postNumber);
	public List<PostBoxVO> postShowSendList(String pageNo, String id,String auth);
	public int sendPostTotal(String id, String auth);
	public List<PostBoxVO> postShowReceiveList(String pageNo, String id,String auth);
	public int receiverPostTotal(String id, String auth);

}
